package com.bayihouse.model.excel;

import com.alibaba.excel.annotation.ExcelProperty;
import com.bayihouse.excel.converter.*;
import lombok.*;

import java.io.Serializable;
import java.util.Date;

/**
 *
 * @TableName occupant
 */
@Data
@AllArgsConstructor
@NoArgsConstructor
@ToString
@EqualsAndHashCode
public class ExcelOccupant implements Serializable {
    private static final long serialVersionUID = 6003839286501928210L;

    /**
     * 入住人员姓名
     */
    @ExcelProperty(value = "姓名")
    private String name;

    /**
     * 身份证号
     */
    @ExcelProperty(value = "证件号码")
    private String identity;

    /**
     * 0代表女的,1代表男的
     */
    @ExcelProperty(value = "性别", converter = SexConverter.class)
    private Integer sex;


    /**
     * 民族
     */
    @ExcelProperty(value = "民族")
    private String ethnicity;

    /**
     * 证件类型
     */
    @ExcelProperty("证件类型")
    private String idType;


    /**
     * 电话
     */
    @ExcelProperty(value = "联系电话")
    private String telephone;

    /**
     * 是否结婚
     */
    @ExcelProperty(value = "婚姻状况", converter = IsMarriageConverter.class)
    private Integer isMarriage;


    @ExcelProperty(value = "协管人员")
    private String mannagerName;

    @ExcelProperty(value = "协管人员手机号")
    private String mannagerTelephone;




    /**
     * 文化程度
     */
    @ExcelProperty(value = "文化程度")
    private String education;

    /**
     * 政治面貌
     */
    @ExcelProperty(value = "政治面貌")
    private String polOutlook;


    @ExcelProperty(value = "采集社区")
    private String community;


    @ExcelProperty(value = "从业处所")
    private String workplace;


    /**
     * 曾用名
     */
    @ExcelProperty(value = "曾用名")
    private String nickname;

    /**
     * 身高
     */
    @ExcelProperty(value = "身高")
    private Double height;


    @ExcelProperty(value = "户口类型")
    private String accountType;

    @ExcelProperty(value = "居住证有效期",converter = MyDateConverter.class)
    private Date stayTime;


    /**
     * 体型
     */
    @ExcelProperty(value = "体型")
    private String somatotype;


    @ExcelProperty(value = "注销日期",converter = MyDateConverter.class)
    private Date deleteTime;

    /**
     * 脸型
     */
    @ExcelProperty(value = "脸型")
    private String face;

    /**
     * 血型
     */
    @ExcelProperty(value = "血型")
    private String bloodType;

    /**
     * 婚证编号
     */
    @ExcelProperty(value = "婚证编号")
    private String MCNumber;

    /**
     * 标签,比如说,敏感人员,常驻人口,租户标签
     */
    @ExcelProperty(value = "人员标签", converter = LabelConverter.class)
    private String label;

    @ExcelProperty(value = "人员类别")
    private String personType;


    /**
     * 户籍-详细地址
     */
    @ExcelProperty(value = "户籍详址")
    private String address;

    /**
     * 用户添加的时间
     */
    @ExcelProperty(value = "登记时间", converter = MyDateConverter.class)
    private Date createTime;



    /**
     * 户籍所在省份
     */
    @ExcelProperty(value = "户籍（省）")
    private String province;

    /**
     * 户籍所在城市
     */
    @ExcelProperty(value = "户籍（地州）")
    private String city;

    /**
     * 户籍所在县,区
     */
    @ExcelProperty(value = "户籍（县）")
    private String street;

    @ExcelProperty(value = "所属街道(管委会)")
    private String mannageStreet;


    @ExcelProperty(value = "所属区县")
    private String district;




    /**
     * 节育措施
     */
    @ExcelProperty(value = "节育措施")
    private String jieyumeasure;



    /**
     * 现居住地
     */
    @ExcelProperty(value = "现住地址")
    private String nowAddress;

    /**
     * 录入人员
     */
    @ExcelProperty(value = "录入人员")
    private String addUserName;


    @ExcelProperty(value = "录入人联系电话")
    private String addUserTelephone;


    @ExcelProperty(value = "房屋类型")
    private String roomType;






    /**
     * 来本地事由
     */
    @ExcelProperty(value = "来本地事由")
    private String PReason;

    /**
     * 职业
     */
    @ExcelProperty(value = "现从事职业")
    private String work;

    /**
     * 孩子数量
     */
    @ExcelProperty(value = "子女数")
    private Integer childNum;

    /**
     * 婚育证编号
     */
    @ExcelProperty(value = "婚育证编号")
    private String supportNumber;

    /**
     * 房子产权证号
     */
    @ExcelProperty(value = "房子产权证号")
    private String certificateNumber;

    @ExcelProperty(value = "最新务工地址")
    private String newWorkplace;

    @ExcelProperty(value = "最新居住地址")
    private String newLivingPlace;

    @ExcelProperty(value = "房屋标签")
    private String roomLabel;

}

